Inventory Reconciliation History Report

The Inventory Reconciliation History report can be used to perform routine cycle counts by generating a list of DINs to perform physical counts for. The report can be used in combination with the Reconcile module to update Actual on Hand values.

The report excludes drugs flagged as PFS or POS Product and mixtures.

There are two parts to complete when using the Inventory Reconciliation History report:

1. Running the Inventory Reconciliation History report.

2. Using the Inventory Reconcile module.

Part 1: Run the Inventory Reconciliation History Report

To run the Inventory Reconciliation History report:

1. From the Workbench, select > Reports > Propel Rx Reports. The Reports window appears.

2. Select Inventory > Inventory Reconciliation History Report > Next.

   

   The Inventory Reconciliation History Report window appears.

3. In the Basic section, select one of the following options:

   • All Drugs - drugs that have an Actual on Hand, a balance owing or had movement since the last reconciliation.

   • Specific Drug/DIN - multiple drugs can be entered and separated by a forward slash (/).

   • Random - drugs that have an Actual on Hand, a balance owing, or had movement since the last reconciliation and have not been reconciled in the last 14 days.

   

4. In the Extended section, select:

   • Drug Category

     • Regular - generates the report for regular drugs.

     • Narcotic/Controlled/Targeted - generates the report for narcotic drugs, controlled drugs, or targeted substances.

     • All Categories - generates the report for regular and narcotic/controlled/targeted drugs.

   • Sort By

     • Trade Name - sorts the drugs on the report alphabetically by trade name.

     • Rx Volume (Script Count) - sorts the drugs on the report by prescription volume in descending order.

     • Highest Unit Cost - sorts the drugs on the report from highest to lowest Acq Cost.

     • Oldest Reconciliation Date - sorts the drugs on the report from the oldest to most recent Last Reconciled Date.

   • Return Value

     • Percent of Total Eligible - generates the report for the specified percentage of eligible drugs according to the Criteria and Extended Criteria. The default percentage is 25%.

     • # DINs to Include - generates the report for the specified number of eligible drugs according to the Criteria and Extended Criteria. The default value is 10.

   

5. Select Print. The Inventory Reconciliation History report is generated and prints.

   Inventory Reconciliation History Report Sample

   

6. Proceed to Part 2: Use the Inventory Reconcile Module.

Part 2: Use the Inventory Reconcile Module

To use the Reconcile module after generating the Inventory Reconciliation History report:

1. From the Workbench, select > Inventory > Reconcile. The Reconcile module opens.

2. In the Search Criteria section, select the Last Reconciliation Report checkbox.

   

3. Select Search. The Search Criteria will collapse and results that match the search criteria display.

   

4. In the Actual on Hand field, enter the physical count of the drug.

   

   • The ReOrder (PT) and ReOrder (PK) fields are enabled and can be edited, if required.

     

5. If the Variance is negative, the following information must be entered:

   • Reason - select the appropriate reason from the dropdown.

   • Comments - add information pertaining to specific reasons (e.g., prescription numbers or return reference numbers).

   

6. Select Submit.

   If there are blank Actual on Hand values, when submitted they have a Reason of NOT RECONCILED.

   A prompt displays.

7. Select the pharmacist's initials from the dropdown.

   

8. Select OK. A confirmation window displays to show that the reconciliation was successful.

9. Select Print to print the Reconciliation Summary report.

   

   Confirm the Reconciliation Summary report successfully printed. If not, select Print again as the report cannot be retrieved once it is closed.

Once a reconciliation is submitted:

• The Actual on Hand, Re-Order Point and Re-Order # Packs fields are updated in the Drug Folder.

• An entry is written to the Shipment Details window and the Drug FolderHistory tab.